SELECT * FROM products LEFT JOIN product_description ON (products.id = product_description.product_id) LEFT JOIN product_to_category ON (products.id = product_to_category.product_id) WHERE lang_id='nl' AND category_id='102' AND active='1' ORDER BY title desc LIMIT 18 OFFSET 0

Spiraalbuis koppelingen

Toon producten 9 18 36 72 | Sorteer op: Prijs oplopend Prijs aflopend Titel oplopend Titel aflopend
Toon pagina: 1 2
Fix-It™
Aansluitset 1�'' BI DN25
(Art. nr. 1520001001)
Prijs
€ 22,40
Toon pagina: 1 2
Winkelmandje
0 item(s) - € 0,00